#!/usr/bin/python
# -*- coding: utf-8 -*-
# @version        : 1.0
# @Create Time    : 2024/9/6 11:11
# @File           : feature
# @IDE            : PyCharm
# @desc           : 描述

from sqlalchemy.orm import Mapped, mapped_column
from db.db_base import AuditModel
from sqlalchemy import String, Text


class DCPlan(AuditModel):
    __tablename__ = "dc_check_plan"
    __table_args__ =  {'comment': '计划待办'}

    part_no: Mapped[str] = mapped_column(String(40), comment="材料/零件图号")
    part_name: Mapped[str] = mapped_column(String(40), comment="材料/零件名称")

    plan_type: Mapped[str] = mapped_column(String(10), comment="待办类型")
    form_no:  Mapped[str] = mapped_column(Text, comment="单据编号")

    content: Mapped[str] = mapped_column(Text, nullable=True, comment="内容")

    status: Mapped[str] = mapped_column(String(20), default="未处理", comment="状态")
